Overview

Dataset statistics

Number of variables18
Number of observations1300
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory174.4 KiB
Average record size in memory137.4 B

Variable types

Text9
DateTime2
Numeric2
Boolean1
Categorical3
Unsupported1

Alerts

user_ratings is highly overall correlated with vader_sentiment and 1 other fieldsHigh correlation
vader_sentiment is highly overall correlated with user_ratings and 2 other fieldsHigh correlation
would_recommed_to_others is highly overall correlated with user_ratings and 2 other fieldsHigh correlation
vader_upper_binned is highly overall correlated with vader_sentiment and 1 other fieldsHigh correlation
reviews has unique valuesUnique
reviews_lemm_spacy has unique valuesUnique
vader_nnp is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-02-05 01:59:47.592149
Analysis finished2024-02-05 01:59:53.821752
Duration6.23 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

title
Text

Distinct1278
Distinct (%)98.3%
Missing0
Missing (%)0.0%
Memory size10.3 KiB
2024-02-05T01:59:54.286694image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Length

Max length81
Median length54
Mean length30.569231
Min length13

Characters and Unicode

Total characters39740
Distinct characters81
Distinct categories11 ?
Distinct scripts2 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1265 ?
Unique (%)97.3%

Sample

1st row“Worst service ever”
2nd row"unprofessional attitude of the pilots"
3rd row“Next time it will be Jet2”
4th row“become the Ryanair of long-haul travel”
5th row“They never help us”
ValueCountFrequency (%)
the 184
 
2.9%
a 171
 
2.7%
was 169
 
2.6%
to 140
 
2.2%
service 129
 
2.0%
flight 115
 
1.8%
and 111
 
1.7%
very 101
 
1.6%
ba 93
 
1.4%
not 81
 
1.3%
Other values (1403) 5130
79.9%
2024-02-05T01:59:55.619790image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5154
13.0%
e 4061
 
10.2%
" 2542
 
6.4%
a 2452
 
6.2%
t 2330
 
5.9%
o 2210
 
5.6%
i 2200
 
5.5%
r 2162
 
5.4%
s 1985
 
5.0%
n 1953
 
4.9%
Other values (71) 12691
31.9%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 30900
77.8%
Space Separator 5155
 
13.0%
Other Punctuation 2654
 
6.7%
Uppercase Letter 806
 
2.0%
Decimal Number 101
 
0.3%
Final Punctuation 46
 
0.1%
Dash Punctuation 40
 
0.1%
Initial Punctuation 19
 
< 0.1%
Control 16
 
< 0.1%
Currency Symbol 2
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 4061
13.1%
a 2452
 
7.9%
t 2330
 
7.5%
o 2210
 
7.2%
i 2200
 
7.1%
r 2162
 
7.0%
s 1985
 
6.4%
n 1953
 
6.3%
l 1610
 
5.2%
d 1186
 
3.8%
Other values (16) 8751
28.3%
Uppercase Letter
ValueCountFrequency (%)
A 176
21.8%
B 145
18.0%
I 93
11.5%
C 56
 
6.9%
T 52
 
6.5%
S 40
 
5.0%
O 27
 
3.3%
F 26
 
3.2%
W 26
 
3.2%
E 26
 
3.2%
Other values (15) 139
17.2%
Decimal Number
ValueCountFrequency (%)
2 20
19.8%
5 17
16.8%
0 14
13.9%
7 12
11.9%
3 11
10.9%
1 10
9.9%
4 10
9.9%
6 4
 
4.0%
8 2
 
2.0%
9 1
 
1.0%
Other Punctuation
ValueCountFrequency (%)
" 2542
95.8%
, 49
 
1.8%
' 38
 
1.4%
! 9
 
0.3%
/ 7
 
0.3%
. 5
 
0.2%
% 2
 
0.1%
\ 1
 
< 0.1%
; 1
 
< 0.1%
Space Separator
ValueCountFrequency (%)
5154
> 99.9%
  1
 
< 0.1%
Final Punctuation
ValueCountFrequency (%)
28
60.9%
18
39.1%
Control
ValueCountFrequency (%)
8
50.0%
8
50.0%
Currency Symbol
ValueCountFrequency (%)
£ 1
50.0%
1
50.0%
Dash Punctuation
ValueCountFrequency (%)
- 40
100.0%
Initial Punctuation
ValueCountFrequency (%)
19
100.0%
Other Number
ValueCountFrequency (%)
½ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 31706
79.8%
Common 8034
 
20.2%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 4061
12.8%
a 2452
 
7.7%
t 2330
 
7.3%
o 2210
 
7.0%
i 2200
 
6.9%
r 2162
 
6.8%
s 1985
 
6.3%
n 1953
 
6.2%
l 1610
 
5.1%
d 1186
 
3.7%
Other values (41) 9557
30.1%
Common
ValueCountFrequency (%)
5154
64.2%
" 2542
31.6%
, 49
 
0.6%
- 40
 
0.5%
' 38
 
0.5%
28
 
0.3%
2 20
 
0.2%
19
 
0.2%
18
 
0.2%
5 17
 
0.2%
Other values (20) 109
 
1.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 39671
99.8%
Punctuation 65
 
0.2%
None 3
 
< 0.1%
Currency Symbols 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5154
13.0%
e 4061
 
10.2%
" 2542
 
6.4%
a 2452
 
6.2%
t 2330
 
5.9%
o 2210
 
5.6%
i 2200
 
5.5%
r 2162
 
5.4%
s 1985
 
5.0%
n 1953
 
4.9%
Other values (64) 12622
31.8%
Punctuation
ValueCountFrequency (%)
28
43.1%
19
29.2%
18
27.7%
None
ValueCountFrequency (%)
£ 1
33.3%
½ 1
33.3%
  1
33.3%
Currency Symbols
ValueCountFrequency (%)
1
100.0%

reviews
Text

UNIQUE 

Distinct1300
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size10.3 KiB
2024-02-05T01:59:56.337062image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Length

Max length3491
Median length1102.5
Mean length827.43
Min length131

Characters and Unicode

Total characters1075659
Distinct characters106
Distinct categories16 ?
Distinct scripts2 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1300 ?
Unique (%)100.0%

Sample

1st row Worst service ever. Lost baggage because of delayed flight and missed connection and no one is helping to get it back. British Airways website is broken so it doesn’t let me fill missing report and doesn’t give me missing file report number and so no way to contact British Airways because they have dumbest ever AI chatbot.
2nd row  BA 246 21JAN 2023 Did not appreciate the unprofessional attitude of the pilots. Flight scheduled departure 16:20. Advised boarding time 15:20. Whole flight full of passengers waiting at the gate to board at 15:20. 15:40 the cabin crew board. 15:55 the pilots board - each with a Sao Paulo Airport Duty Free branded shopping bag. 16:20 the flight is still boarding. Finally pushes back just before 17:00, 40 minutes late. Captain came on the intercom to announce the delay was due to 'traffic between the crew hotel and the airport'. Sorry Captain the whole plane saw you and your pilot colleagues board fifteen minutes after the cabin crew clutching your duty free that you and your pilot colleagues still made time to stop for.
3rd row Not a great experience. I could not check in online as two separate parts of the BA computer system do not talk to each other. At LHR a delightful check in clerk sorted it quickly, manually! We boarded on time, but luggage loading had to be halted as the Captain spotted a technical issue and an engineer was called. By the time it was sorted we had missed our slot so took off an hour behind schedule. The flight was uneventful, but the plane had clearly seen better days, legroom was appalling and the handout of a small bottle of water and a soggy cookie made one wish for the days when flying BA meant something special. Next time it will be Jet2.
4th row I was excited to fly BA as I'd not travelled with them long haul for over 25yrs. I've travelled to Australia on many occasions, so I've pretty much travelled with them all. Terrible was my experience. BA have become the Ryanair of long-haul travel, riding on their previous good name and reputation. We were delayed for 5hrs at the terminal, where we were offered one glass of water and then at the last minute our meal - with no additional drinks offered. The charging points were outdated and 3 out of 5 didn't work (family of five travelling). The in flight entertainment was also outdated and the movies available were poor compared to other airlines. The food was atrocious - we flew BA LHR-HongKong and return and Cathay HK-Australia return and the comparison was vast. We were offered pre meal drinks and snacks, drinks with our meal, a menu for our flights so we knew our choices, the quality of the food was vastly better with Cathay. Our luggage was lost for nearly two hours in Hong Kong and when we arrived into London, one of our bags was so badly damaged it was unusable. The only redeeming part was the crew on our return flight were amazing. Severine was an angel and helped make the journey more pleasant for my kids.
5th row I just want to warn everyone of the worst customer service experience ever! It really looks like British Airways customer service over the phone are trained to not help you in anyway and to create more problems rather than solving them. Last week we called British Airways to make a reservation for the family. At the time we explained to the customer service representative that we wanted to make a booking and then pay with a transfer of miles from American Express. The representative told us that he could not make the reservation until the miles were in the account, and asked us to contact American Express and make the transfer so that the booking could be made. The conversation was recorded by British Airways and could be checked. We immediately called AMEX (within 30 minutes) and solicited the transfer of 500K miles. AMEX clearly stated to us whether we were sure as the transfer was not reversible. We said that it was fine since we had checked previously with British Airways. We then called British Airways immediately to make our reservation to Miami. They confirmed that the miles arrived to our account, but to our surprise they told us that there was no space (not even one seat to Miami) and that we could not use the miles. We explained the situation and how we were led to believe that we could have a flight with miles if we transferred the miles, but all this went on deaf ears. We called the German office, which was absolutely unhelpful, so we also called UK customer service which was just as unhelpful. No manager was able to open a flight for us with miles and they just kept repeating that this was not possible (even though we if we paid for the flight and got the seats and also seats were available if we would have had gold status). In the end British Airways took absolutely no responsibility for causing the problem, did not give us a solution, kept our miles and we have to pay for a trip to Miami. With this service to their customers this is a company that should not be in business. Every time we call they made us wait for over 45 minutes then they answer and put us on hold, I have 2 days of waiting and talking with British Airways for over 2 hours each day, we were on the line for over 45 minutes each time. We were told by the lady agent to hang up the phone as I was too long on the phone and she had other customers? And we are not customers? They never help us.
ValueCountFrequency (%)
the 9821
 
5.0%
to 6869
 
3.5%
and 5923
 
3.0%
was 4406
 
2.3%
a 4303
 
2.2%
i 3984
 
2.0%
in 2673
 
1.4%
of 2672
 
1.4%
flight 2412
 
1.2%
on 2387
 
1.2%
Other values (9594) 149863
76.7%
2024-02-05T01:59:57.655270image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
196726
18.3%
e 102075
 
9.5%
t 74768
 
7.0%
a 69482
 
6.5%
o 63608
 
5.9%
n 56706
 
5.3%
i 53010
 
4.9%
r 50086
 
4.7%
s 49321
 
4.6%
h 40593
 
3.8%
Other values (96) 319284
29.7%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 819745
76.2%
Space Separator 196770
 
18.3%
Uppercase Letter 28412
 
2.6%
Other Punctuation 20048
 
1.9%
Decimal Number 6793
 
0.6%
Dash Punctuation 1424
 
0.1%
Final Punctuation 786
 
0.1%
Close Punctuation 628
 
0.1%
Open Punctuation 623
 
0.1%
Currency Symbol 238
 
< 0.1%
Other values (6) 192
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 102075
12.5%
t 74768
 
9.1%
a 69482
 
8.5%
o 63608
 
7.8%
n 56706
 
6.9%
i 53010
 
6.5%
r 50086
 
6.1%
s 49321
 
6.0%
h 40593
 
5.0%
l 36075
 
4.4%
Other values (22) 224021
27.3%
Uppercase Letter
ValueCountFrequency (%)
I 5011
17.6%
A 4063
14.3%
T 3146
11.1%
B 3091
10.9%
L 1397
 
4.9%
C 1260
 
4.4%
W 1172
 
4.1%
S 1101
 
3.9%
H 1044
 
3.7%
F 993
 
3.5%
Other values (16) 6134
21.6%
Other Punctuation
ValueCountFrequency (%)
. 11890
59.3%
, 5760
28.7%
' 1070
 
5.3%
! 354
 
1.8%
" 243
 
1.2%
/ 225
 
1.1%
: 157
 
0.8%
? 155
 
0.8%
& 88
 
0.4%
; 56
 
0.3%
Other values (4) 50
 
0.2%
Decimal Number
ValueCountFrequency (%)
0 1335
19.7%
2 1194
17.6%
1 970
14.3%
3 770
11.3%
5 704
10.4%
7 573
8.4%
4 523
 
7.7%
8 300
 
4.4%
6 219
 
3.2%
9 205
 
3.0%
Dash Punctuation
ValueCountFrequency (%)
- 1395
98.0%
22
 
1.5%
7
 
0.5%
Currency Symbol
ValueCountFrequency (%)
£ 128
53.8%
$ 98
41.2%
12
 
5.0%
Math Symbol
ValueCountFrequency (%)
+ 45
83.3%
> 8
 
14.8%
~ 1
 
1.9%
Space Separator
ValueCountFrequency (%)
196726
> 99.9%
  44
 
< 0.1%
Final Punctuation
ValueCountFrequency (%)
723
92.0%
63
 
8.0%
Close Punctuation
ValueCountFrequency (%)
) 627
99.8%
] 1
 
0.2%
Open Punctuation
ValueCountFrequency (%)
( 622
99.8%
[ 1
 
0.2%
Initial Punctuation
ValueCountFrequency (%)
64
73.6%
23
 
26.4%
Control
ValueCountFrequency (%)
22
50.0%
22
50.0%
Line Separator
ValueCountFrequency (%)
3
100.0%
Other Number
ValueCountFrequency (%)
½ 2
100.0%
Modifier Symbol
ValueCountFrequency (%)
´ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 848157
78.8%
Common 227502
 
21.2%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 102075
12.0%
t 74768
 
8.8%
a 69482
 
8.2%
o 63608
 
7.5%
n 56706
 
6.7%
i 53010
 
6.3%
r 50086
 
5.9%
s 49321
 
5.8%
h 40593
 
4.8%
l 36075
 
4.3%
Other values (48) 252433
29.8%
Common
ValueCountFrequency (%)
196726
86.5%
. 11890
 
5.2%
, 5760
 
2.5%
- 1395
 
0.6%
0 1335
 
0.6%
2 1194
 
0.5%
' 1070
 
0.5%
1 970
 
0.4%
3 770
 
0.3%
723
 
0.3%
Other values (38) 5669
 
2.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1074538
99.9%
Punctuation 915
 
0.1%
None 194
 
< 0.1%
Currency Symbols 12
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
196726
18.3%
e 102075
 
9.5%
t 74768
 
7.0%
a 69482
 
6.5%
o 63608
 
5.9%
n 56706
 
5.3%
i 53010
 
4.9%
r 50086
 
4.7%
s 49321
 
4.6%
h 40593
 
3.8%
Other values (77) 318163
29.6%
Punctuation
ValueCountFrequency (%)
723
79.0%
64
 
7.0%
63
 
6.9%
23
 
2.5%
22
 
2.4%
10
 
1.1%
7
 
0.8%
3
 
0.3%
None
ValueCountFrequency (%)
£ 128
66.0%
  44
 
22.7%
ä 6
 
3.1%
ü 4
 
2.1%
é 3
 
1.5%
í 3
 
1.5%
½ 2
 
1.0%
´ 2
 
1.0%
ö 1
 
0.5%
ã 1
 
0.5%
Currency Symbols
ValueCountFrequency (%)
12
100.0%
Distinct901
Distinct (%)69.3%
Missing0
Missing (%)0.0%
Memory size10.3 KiB
Minimum2018-03-28 00:00:00
Maximum2024-01-23 00:00:00
2024-02-05T01:59:58.160576image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
2024-02-05T01:59:58.711110image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct1112
Distinct (%)85.5%
Missing0
Missing (%)0.0%
Memory size10.3 KiB
2024-02-05T01:59:59.352025image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Length

Max length33
Median length28
Mean length13.369231
Min length4

Characters and Unicode

Total characters17380
Distinct characters68
Distinct categories6 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1027 ?
Unique (%)79.0%

Sample

1st rowChirag Thummar
2nd rowD Carreno
3rd rowSimon Channon
4th rowMelissa Harris
5th rowIvana Squassabia
ValueCountFrequency (%)
s 65
 
2.3%
m 50
 
1.7%
a 44
 
1.5%
c 44
 
1.5%
e 43
 
1.5%
1 43
 
1.5%
r 40
 
1.4%
j 35
 
1.2%
31 34
 
1.2%
ellis 29
 
1.0%
Other values (1352) 2446
85.1%
2024-02-05T02:00:00.232804image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2885
16.6%
e 1710
 
9.8%
a 1319
 
7.6%
r 1110
 
6.4%
i 999
 
5.7%
n 901
 
5.2%
s 775
 
4.5%
o 706
 
4.1%
l 656
 
3.8%
t 420
 
2.4%
Other values (58) 5899
33.9%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 11439
65.8%
Space Separator 2885
 
16.6%
Uppercase Letter 2657
 
15.3%
Decimal Number 384
 
2.2%
Dash Punctuation 11
 
0.1%
Other Punctuation 4
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 1710
14.9%
a 1319
11.5%
r 1110
9.7%
i 999
8.7%
n 901
 
7.9%
s 775
 
6.8%
o 706
 
6.2%
l 656
 
5.7%
t 420
 
3.7%
v 382
 
3.3%
Other values (18) 2461
21.5%
Uppercase Letter
ValueCountFrequency (%)
M 280
 
10.5%
S 237
 
8.9%
C 189
 
7.1%
D 175
 
6.6%
A 172
 
6.5%
R 154
 
5.8%
B 151
 
5.7%
J 137
 
5.2%
G 135
 
5.1%
H 134
 
5.0%
Other values (16) 893
33.6%
Decimal Number
ValueCountFrequency (%)
1 119
31.0%
3 78
20.3%
2 58
15.1%
4 40
 
10.4%
6 24
 
6.2%
0 18
 
4.7%
8 16
 
4.2%
5 13
 
3.4%
7 10
 
2.6%
9 8
 
2.1%
Other Punctuation
ValueCountFrequency (%)
' 2
50.0%
. 2
50.0%
Space Separator
ValueCountFrequency (%)
2885
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 14096
81.1%
Common 3284
 
18.9%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 1710
 
12.1%
a 1319
 
9.4%
r 1110
 
7.9%
i 999
 
7.1%
n 901
 
6.4%
s 775
 
5.5%
o 706
 
5.0%
l 656
 
4.7%
t 420
 
3.0%
v 382
 
2.7%
Other values (44) 5118
36.3%
Common
ValueCountFrequency (%)
2885
87.9%
1 119
 
3.6%
3 78
 
2.4%
2 58
 
1.8%
4 40
 
1.2%
6 24
 
0.7%
0 18
 
0.5%
8 16
 
0.5%
5 13
 
0.4%
- 11
 
0.3%
Other values (4) 22
 
0.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 17374
> 99.9%
None 6
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2885
16.6%
e 1710
 
9.8%
a 1319
 
7.6%
r 1110
 
6.4%
i 999
 
5.7%
n 901
 
5.2%
s 775
 
4.5%
o 706
 
4.1%
l 656
 
3.8%
t 420
 
2.4%
Other values (56) 5893
33.9%
None
ValueCountFrequency (%)
é 4
66.7%
ö 2
33.3%
Distinct57
Distinct (%)4.4%
Missing0
Missing (%)0.0%
Memory size10.3 KiB
2024-02-05T02:00:00.666847image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Length

Max length21
Median length14
Mean length12.222308
Min length5

Characters and Unicode

Total characters15889
Distinct characters46
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique18 ?
Unique (%)1.4%

Sample

1st rowGermany
2nd rowUnited Kingdom
3rd rowUnited Kingdom
4th rowUnited Kingdom
5th rowGermany
ValueCountFrequency (%)
united 952
41.3%
kingdom 739
32.0%
states 202
 
8.8%
australia 44
 
1.9%
canada 42
 
1.8%
germany 30
 
1.3%
south 22
 
1.0%
africa 20
 
0.9%
ireland 16
 
0.7%
switzerland 15
 
0.7%
Other values (58) 225
 
9.8%
2024-02-05T02:00:01.676785image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
n 1928
12.1%
i 1870
11.8%
d 1823
11.5%
t 1490
9.4%
e 1364
8.6%
1007
 
6.3%
U 952
 
6.0%
o 807
 
5.1%
m 795
 
5.0%
g 781
 
4.9%
Other values (36) 3072
19.3%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 12576
79.1%
Uppercase Letter 2306
 
14.5%
Space Separator 1007
 
6.3%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
n 1928
15.3%
i 1870
14.9%
d 1823
14.5%
t 1490
11.8%
e 1364
10.8%
o 807
6.4%
m 795
6.3%
g 781
6.2%
a 701
 
5.6%
s 290
 
2.3%
Other values (14) 727
 
5.8%
Uppercase Letter
ValueCountFrequency (%)
U 952
41.3%
K 754
32.7%
S 275
 
11.9%
A 82
 
3.6%
C 51
 
2.2%
I 41
 
1.8%
G 40
 
1.7%
N 23
 
1.0%
F 13
 
0.6%
B 12
 
0.5%
Other values (11) 63
 
2.7%
Space Separator
ValueCountFrequency (%)
1007
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 14882
93.7%
Common 1007
 
6.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
n 1928
13.0%
i 1870
12.6%
d 1823
12.2%
t 1490
10.0%
e 1364
9.2%
U 952
6.4%
o 807
 
5.4%
m 795
 
5.3%
g 781
 
5.2%
K 754
 
5.1%
Other values (35) 2318
15.6%
Common
ValueCountFrequency (%)
1007
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 15889
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
n 1928
12.1%
i 1870
11.8%
d 1823
11.5%
t 1490
9.4%
e 1364
8.6%
1007
 
6.3%
U 952
 
6.0%
o 807
 
5.1%
m 795
 
5.0%
g 781
 
4.9%
Other values (36) 3072
19.3%

user_ratings
Real number (ℝ)

HIGH CORRELATION 

Distinct10
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.1746154
Minimum1
Maximum10
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.3 KiB
2024-02-05T02:00:02.142715image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median3
Q37
95-th percentile10
Maximum10
Range9
Interquartile range (IQR)6

Descriptive statistics

Standard deviation3.2533943
Coefficient of variation (CV)0.77932792
Kurtosis-1.2046091
Mean4.1746154
Median Absolute Deviation (MAD)2
Skewness0.57513754
Sum5427
Variance10.584575
MonotonicityNot monotonic
2024-02-05T02:00:02.570706image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
1 436
33.5%
2 154
 
11.8%
3 125
 
9.6%
10 118
 
9.1%
8 100
 
7.7%
9 93
 
7.2%
4 82
 
6.3%
7 75
 
5.8%
5 64
 
4.9%
6 53
 
4.1%
ValueCountFrequency (%)
1 436
33.5%
2 154
 
11.8%
3 125
 
9.6%
4 82
 
6.3%
5 64
 
4.9%
6 53
 
4.1%
7 75
 
5.8%
8 100
 
7.7%
9 93
 
7.2%
10 118
 
9.1%
ValueCountFrequency (%)
10 118
 
9.1%
9 93
 
7.2%
8 100
 
7.7%
7 75
 
5.8%
6 53
 
4.1%
5 64
 
4.9%
4 82
 
6.3%
3 125
 
9.6%
2 154
 
11.8%
1 436
33.5%
Distinct1297
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Memory size10.3 KiB
2024-02-05T02:00:03.157346image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Length

Max length158
Median length133
Mean length112.96385
Min length65

Characters and Unicode

Total characters146853
Distinct characters71
Distinct categories9 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1294 ?
Unique (%)99.5%

Sample

1st rowType Of TravellerSolo Leisure Seat TypeEconomy Class RouteBoston to Düsseldorf via London Date FlownJanuary 2024
2nd rowAircraftA350 Type Of TravellerBusiness Seat TypeEconomy Class RouteSao Paulo to London Heathrow Date FlownJanuary 2024
3rd rowAircraftA320 Type Of TravellerCouple Leisure Seat TypeEconomy Class RouteLondon Heathrow to Lisbon Date FlownJanuary 2024
4th rowType Of TravellerFamily Leisure Seat TypeEconomy Class RouteLondon to Hong Kong Date FlownJanuary 2024
5th rowType Of TravellerFamily Leisure Seat TypeBusiness Class RouteDusseldorf (DUS) to Miami (MIA) Date FlownJanuary 2024
ValueCountFrequency (%)
date 1300
 
6.9%
seat 1300
 
6.9%
of 1298
 
6.9%
type 1298
 
6.9%
to 1296
 
6.8%
class 1187
 
6.3%
leisure 1043
 
5.5%
typeeconomy 724
 
3.8%
london 619
 
3.3%
routelondon 485
 
2.6%
Other values (522) 8377
44.3%
2024-02-05T02:00:04.358279image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 15310
 
10.4%
13075
 
8.9%
o 10811
 
7.4%
a 8583
 
5.8%
r 7292
 
5.0%
t 7155
 
4.9%
l 6850
 
4.7%
n 6598
 
4.5%
s 6198
 
4.2%
4635
 
3.2%
Other values (61) 60346
41.1%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 99157
67.5%
Uppercase Letter 21693
 
14.8%
Space Separator 13075
 
8.9%
Decimal Number 8039
 
5.5%
Control 4635
 
3.2%
Dash Punctuation 192
 
0.1%
Other Punctuation 54
 
< 0.1%
Open Punctuation 4
 
< 0.1%
Close Punctuation 4
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 15310
15.4%
o 10811
10.9%
a 8583
8.7%
r 7292
 
7.4%
t 7155
 
7.2%
l 6850
 
6.9%
n 6598
 
6.7%
s 6198
 
6.3%
u 4591
 
4.6%
i 4347
 
4.4%
Other values (18) 21422
21.6%
Uppercase Letter
ValueCountFrequency (%)
T 4004
18.5%
L 2268
10.5%
S 1991
9.2%
C 1774
8.2%
F 1700
7.8%
D 1553
 
7.2%
A 1517
 
7.0%
O 1438
 
6.6%
R 1337
 
6.2%
B 1193
 
5.5%
Other values (16) 2918
13.5%
Decimal Number
ValueCountFrequency (%)
2 2537
31.6%
0 2004
24.9%
7 901
 
11.2%
1 826
 
10.3%
3 717
 
8.9%
8 464
 
5.8%
9 420
 
5.2%
4 141
 
1.8%
5 24
 
0.3%
6 5
 
0.1%
Other Punctuation
ValueCountFrequency (%)
/ 46
85.2%
, 8
 
14.8%
Space Separator
ValueCountFrequency (%)
13075
100.0%
Control
ValueCountFrequency (%)
4635
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 192
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 120850
82.3%
Common 26003
 
17.7%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 15310
 
12.7%
o 10811
 
8.9%
a 8583
 
7.1%
r 7292
 
6.0%
t 7155
 
5.9%
l 6850
 
5.7%
n 6598
 
5.5%
s 6198
 
5.1%
u 4591
 
3.8%
i 4347
 
3.6%
Other values (44) 43115
35.7%
Common
ValueCountFrequency (%)
13075
50.3%
4635
 
17.8%
2 2537
 
9.8%
0 2004
 
7.7%
7 901
 
3.5%
1 826
 
3.2%
3 717
 
2.8%
8 464
 
1.8%
9 420
 
1.6%
- 192
 
0.7%
Other values (7) 232
 
0.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 146846
> 99.9%
None 7
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
e 15310
 
10.4%
13075
 
8.9%
o 10811
 
7.4%
a 8583
 
5.8%
r 7292
 
5.0%
t 7155
 
4.9%
l 6850
 
4.7%
n 6598
 
4.5%
s 6198
 
4.2%
4635
 
3.2%
Other values (57) 60339
41.1%
None
ValueCountFrequency (%)
ü 3
42.9%
ã 2
28.6%
İ 1
 
14.3%
é 1
 
14.3%

would_recommed_to_others
Boolean

HIGH CORRELATION 

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
False
867 
True
433 
ValueCountFrequency (%)
False 867
66.7%
True 433
33.3%
2024-02-05T02:00:04.792937image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

reviews_lemm_spacy
Text

UNIQUE 

Distinct1300
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size10.3 KiB
2024-02-05T02:00:05.349648image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Length

Max length2126
Median length675
Mean length447.71615
Min length58

Characters and Unicode

Total characters582031
Distinct characters44
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1300 ?
Unique (%)100.0%

Sample

1st rowbad service lose baggage delay flight miss connection help british airways website break let fill missing report missing file report number way contact british airway dumb ai chatbot
2nd rowba 246 21jan 2023 appreciate unprofessional attitude pilot flight schedule departure 1620 advise boarding time 1520 flight passenger wait gate board 1520 1540 cabin crew board 1555 pilot board sao paulo airport duty free brand shopping bag 1620 flight boarding finally push 1700 40 minute late captain come intercom announce delay traffic crew hotel airport sorry captain plane pilot colleague board minute cabin crew clutch duty free pilot colleague time stop
3rd rowgreat experience check online separate ba computer system talk lhr delightful check clerk sort quickly manually board time luggage loading halt captain spot technical issue engineer time sort miss slot hour schedule flight uneventful plane clearly day legroom appalling handout small bottle water soggy cookie wish day fly ba mean special time jet2
4th rowexcited fly ba d travel long haul 25yr ve travel australia occasion ve pretty travel terrible experience ba ryanair longhaul travel riding previous good reputation delay 5hrs terminal offer glass water minute meal additional drink offer charge point outdate 3 5 work family travel flight entertainment outdate movie available poor compare airline food atrocious fly ba lhrhongkong return cathay hkaustralia return comparison vast offer pre meal drink snack drink meal menu flight know choice quality food vastly cathay luggage lose nearly hour hong kong arrive london bag badly damage unusable redeem crew return flight amazing severine angel help journey pleasant kid
5th rowwant warn bad customer service experience look like british airways customer service phone train help create problem solve week british airway reservation family time explain customer service representative want booking pay transfer mile american express representative tell reservation mile account ask contact american express transfer booking conversation record british airways check immediately amex 30 minute solicit transfer 500k mile amex clearly state sure transfer reversible fine check previously british airways british airway immediately reservation miami confirm mile arrive account surprise tell space seat miami use mile explain situation lead believe flight mile transfer mile deaf ear german office absolutely unhelpful uk customer service unhelpful manager able open flight mile repeat possible pay flight seat seat available gold status end british airways absolutely responsibility cause problem solution mile pay trip miami service customer company business time wait 45 minute answer hold 2 day wait talk british airway 2 hour day line 45 minute time tell lady agent hang phone long phone customer customer help
ValueCountFrequency (%)
flight 2777
 
3.2%
ba 1505
 
1.7%
seat 1313
 
1.5%
service 1006
 
1.1%
time 792
 
0.9%
london 791
 
0.9%
hour 710
 
0.8%
good 686
 
0.8%
fly 648
 
0.7%
crew 645
 
0.7%
Other values (7023) 76710
87.6%
2024-02-05T02:00:06.556129image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
86283
14.8%
e 60025
 
10.3%
a 42511
 
7.3%
r 35885
 
6.2%
i 35431
 
6.1%
t 34428
 
5.9%
o 31920
 
5.5%
n 30481
 
5.2%
l 30225
 
5.2%
s 26421
 
4.5%
Other values (34) 168421
28.9%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 488953
84.0%
Space Separator 86283
 
14.8%
Decimal Number 6793
 
1.2%
Other Number 2
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 60025
12.3%
a 42511
 
8.7%
r 35885
 
7.3%
i 35431
 
7.2%
t 34428
 
7.0%
o 31920
 
6.5%
n 30481
 
6.2%
l 30225
 
6.2%
s 26421
 
5.4%
c 21739
 
4.4%
Other values (22) 139887
28.6%
Decimal Number
ValueCountFrequency (%)
0 1335
19.7%
2 1194
17.6%
1 970
14.3%
3 770
11.3%
5 704
10.4%
7 573
8.4%
4 523
 
7.7%
8 300
 
4.4%
6 219
 
3.2%
9 205
 
3.0%
Space Separator
ValueCountFrequency (%)
86283
100.0%
Other Number
ValueCountFrequency (%)
½ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 488953
84.0%
Common 93078
 
16.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 60025
12.3%
a 42511
 
8.7%
r 35885
 
7.3%
i 35431
 
7.2%
t 34428
 
7.0%
o 31920
 
6.5%
n 30481
 
6.2%
l 30225
 
6.2%
s 26421
 
5.4%
c 21739
 
4.4%
Other values (22) 139887
28.6%
Common
ValueCountFrequency (%)
86283
92.7%
0 1335
 
1.4%
2 1194
 
1.3%
1 970
 
1.0%
3 770
 
0.8%
5 704
 
0.8%
7 573
 
0.6%
4 523
 
0.6%
8 300
 
0.3%
6 219
 
0.2%
Other values (2) 207
 
0.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 582011
> 99.9%
None 20
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
86283
14.8%
e 60025
 
10.3%
a 42511
 
7.3%
r 35885
 
6.2%
i 35431
 
6.1%
t 34428
 
5.9%
o 31920
 
5.5%
n 30481
 
5.2%
l 30225
 
5.2%
s 26421
 
4.5%
Other values (27) 168401
28.9%
None
ValueCountFrequency (%)
ä 6
30.0%
ü 4
20.0%
é 3
15.0%
í 3
15.0%
½ 2
 
10.0%
ö 1
 
5.0%
ã 1
 
5.0%
Distinct1181
Distinct (%)90.8%
Missing0
Missing (%)0.0%
Memory size10.3 KiB
2024-02-05T02:00:07.126952image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Length

Max length56
Median length38
Mean length18.787692
Min length0

Characters and Unicode

Total characters24424
Distinct characters38
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1111 ?
Unique (%)85.5%

Sample

1st rowbad service
2nd rowunprofessional attitude pilot
3rd rowtime jet2
4th rowryanair longhaul travel
5th rowhelp
ValueCountFrequency (%)
service 133
 
3.7%
flight 127
 
3.5%
ba 94
 
2.6%
crew 74
 
2.0%
experience 71
 
2.0%
good 66
 
1.8%
seat 65
 
1.8%
airline 57
 
1.6%
bad 52
 
1.4%
customer 49
 
1.4%
Other values (1000) 2827
78.2%
2024-02-05T02:00:08.280848image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 2940
 
12.0%
2319
 
9.5%
a 1797
 
7.4%
i 1712
 
7.0%
r 1666
 
6.8%
t 1369
 
5.6%
o 1367
 
5.6%
l 1350
 
5.5%
n 1233
 
5.0%
s 1201
 
4.9%
Other values (28) 7470
30.6%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 22003
90.1%
Space Separator 2319
 
9.5%
Decimal Number 101
 
0.4%
Other Number 1
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 2940
13.4%
a 1797
 
8.2%
i 1712
 
7.8%
r 1666
 
7.6%
t 1369
 
6.2%
o 1367
 
6.2%
l 1350
 
6.1%
n 1233
 
5.6%
s 1201
 
5.5%
c 1152
 
5.2%
Other values (16) 6216
28.3%
Decimal Number
ValueCountFrequency (%)
2 20
19.8%
5 17
16.8%
0 14
13.9%
7 12
11.9%
3 11
10.9%
1 10
9.9%
4 10
9.9%
6 4
 
4.0%
8 2
 
2.0%
9 1
 
1.0%
Space Separator
ValueCountFrequency (%)
2319
100.0%
Other Number
ValueCountFrequency (%)
½ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 22003
90.1%
Common 2421
 
9.9%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 2940
13.4%
a 1797
 
8.2%
i 1712
 
7.8%
r 1666
 
7.6%
t 1369
 
6.2%
o 1367
 
6.2%
l 1350
 
6.1%
n 1233
 
5.6%
s 1201
 
5.5%
c 1152
 
5.2%
Other values (16) 6216
28.3%
Common
ValueCountFrequency (%)
2319
95.8%
2 20
 
0.8%
5 17
 
0.7%
0 14
 
0.6%
7 12
 
0.5%
3 11
 
0.5%
1 10
 
0.4%
4 10
 
0.4%
6 4
 
0.2%
8 2
 
0.1%
Other values (2) 2
 
0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 24423
> 99.9%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
e 2940
 
12.0%
2319
 
9.5%
a 1797
 
7.4%
i 1712
 
7.0%
r 1666
 
6.8%
t 1369
 
5.6%
o 1367
 
5.6%
l 1350
 
5.5%
n 1233
 
5.0%
s 1201
 
4.9%
Other values (27) 7469
30.6%
None
ValueCountFrequency (%)
½ 1
100.0%
Distinct110
Distinct (%)8.5%
Missing0
Missing (%)0.0%
Memory size10.3 KiB
2024-02-05T02:00:08.750763image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Length

Max length25
Median length24
Mean length6.1069231
Min length3

Characters and Unicode

Total characters7939
Distinct characters40
Distinct categories8 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique72 ?
Unique (%)5.5%

Sample

1st rowunk
2nd rowA350
3rd rowA320
4th rowunk
5th rowunk
ValueCountFrequency (%)
unk 560
31.9%
boeing 343
19.5%
a320 185
 
10.5%
777 103
 
5.9%
a380 75
 
4.3%
a321 49
 
2.8%
777-200 48
 
2.7%
787 42
 
2.4%
747-400 41
 
2.3%
747 38
 
2.2%
Other values (59) 272
15.5%
2024-02-05T02:00:09.589046image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
n 936
11.8%
7 897
 
11.3%
0 610
 
7.7%
u 562
 
7.1%
k 560
 
7.1%
457
 
5.8%
3 449
 
5.7%
A 418
 
5.3%
e 388
 
4.9%
o 376
 
4.7%
Other values (30) 2286
28.8%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 3590
45.2%
Decimal Number 2839
35.8%
Uppercase Letter 819
 
10.3%
Space Separator 457
 
5.8%
Dash Punctuation 188
 
2.4%
Other Punctuation 44
 
0.6%
Open Punctuation 1
 
< 0.1%
Close Punctuation 1
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
n 936
26.1%
u 562
15.7%
k 560
15.6%
e 388
10.8%
o 376
10.5%
i 353
 
9.8%
g 346
 
9.6%
r 25
 
0.7%
a 15
 
0.4%
m 10
 
0.3%
Other values (5) 19
 
0.5%
Decimal Number
ValueCountFrequency (%)
7 897
31.6%
0 610
21.5%
3 449
15.8%
2 338
 
11.9%
8 186
 
6.6%
4 131
 
4.6%
1 115
 
4.1%
9 84
 
3.0%
5 24
 
0.8%
6 5
 
0.2%
Uppercase Letter
ValueCountFrequency (%)
A 418
51.0%
B 355
43.3%
E 21
 
2.6%
N 10
 
1.2%
R 9
 
1.1%
D 2
 
0.2%
O 2
 
0.2%
F 1
 
0.1%
M 1
 
0.1%
Other Punctuation
ValueCountFrequency (%)
/ 39
88.6%
, 5
 
11.4%
Space Separator
ValueCountFrequency (%)
457
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 188
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 4409
55.5%
Common 3530
44.5%

Most frequent character per script

Latin
ValueCountFrequency (%)
n 936
21.2%
u 562
12.7%
k 560
12.7%
A 418
9.5%
e 388
8.8%
o 376
8.5%
B 355
 
8.1%
i 353
 
8.0%
g 346
 
7.8%
r 25
 
0.6%
Other values (14) 90
 
2.0%
Common
ValueCountFrequency (%)
7 897
25.4%
0 610
17.3%
457
12.9%
3 449
12.7%
2 338
 
9.6%
- 188
 
5.3%
8 186
 
5.3%
4 131
 
3.7%
1 115
 
3.3%
9 84
 
2.4%
Other values (6) 75
 
2.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 7939
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
n 936
11.8%
7 897
 
11.3%
0 610
 
7.7%
u 562
 
7.1%
k 560
 
7.1%
457
 
5.8%
3 449
 
5.7%
A 418
 
5.3%
e 388
 
4.9%
o 376
 
4.7%
Other values (30) 2286
28.8%

travel_type
Categorical

Distinct5
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size10.3 KiB
Couple Leisure
433 
Solo Leisure
410 
Business
255 
Family Leisure
200 
unk
 
2

Length

Max length14
Median length12
Mean length12.175385
Min length3

Characters and Unicode

Total characters15828
Distinct characters19
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowSolo Leisure
2nd rowBusiness
3rd rowCouple Leisure
4th rowFamily Leisure
5th rowFamily Leisure

Common Values

ValueCountFrequency (%)
Couple Leisure 433
33.3%
Solo Leisure 410
31.5%
Business 255
19.6%
Family Leisure 200
15.4%
unk 2
 
0.2%

Length

2024-02-05T02:00:09.868938image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-02-05T02:00:10.089687image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
ValueCountFrequency (%)
leisure 1043
44.5%
couple 433
18.5%
solo 410
 
17.5%
business 255
 
10.9%
family 200
 
8.5%
unk 2
 
0.1%

Most occurring characters

ValueCountFrequency (%)
e 2774
17.5%
s 1808
11.4%
u 1733
10.9%
i 1498
9.5%
o 1253
7.9%
r 1043
 
6.6%
l 1043
 
6.6%
1043
 
6.6%
L 1043
 
6.6%
C 433
 
2.7%
Other values (9) 2157
13.6%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 12444
78.6%
Uppercase Letter 2341
 
14.8%
Space Separator 1043
 
6.6%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 2774
22.3%
s 1808
14.5%
u 1733
13.9%
i 1498
12.0%
o 1253
10.1%
r 1043
 
8.4%
l 1043
 
8.4%
p 433
 
3.5%
n 257
 
2.1%
a 200
 
1.6%
Other values (3) 402
 
3.2%
Uppercase Letter
ValueCountFrequency (%)
L 1043
44.6%
C 433
18.5%
S 410
 
17.5%
B 255
 
10.9%
F 200
 
8.5%
Space Separator
ValueCountFrequency (%)
1043
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 14785
93.4%
Common 1043
 
6.6%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 2774
18.8%
s 1808
12.2%
u 1733
11.7%
i 1498
10.1%
o 1253
8.5%
r 1043
 
7.1%
l 1043
 
7.1%
L 1043
 
7.1%
C 433
 
2.9%
p 433
 
2.9%
Other values (8) 1724
11.7%
Common
ValueCountFrequency (%)
1043
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 15828
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
e 2774
17.5%
s 1808
11.4%
u 1733
10.9%
i 1498
9.5%
o 1253
7.9%
r 1043
 
6.6%
l 1043
 
6.6%
1043
 
6.6%
L 1043
 
6.6%
C 433
 
2.7%
Other values (9) 2157
13.6%

seat
Categorical

Distinct4
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size10.3 KiB
Economy Class
724 
Business Class
418 
Premium Economy
113 
First Class
 
45

Length

Max length15
Median length13
Mean length13.426154
Min length11

Characters and Unicode

Total characters17454
Distinct characters19
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowEconomy Class
2nd rowEconomy Class
3rd rowEconomy Class
4th rowEconomy Class
5th rowBusiness Class

Common Values

ValueCountFrequency (%)
Economy Class 724
55.7%
Business Class 418
32.2%
Premium Economy 113
 
8.7%
First Class 45
 
3.5%

Length

2024-02-05T02:00:10.371889image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-02-05T02:00:10.606728image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
ValueCountFrequency (%)
class 1187
45.7%
economy 837
32.2%
business 418
 
16.1%
premium 113
 
4.3%
first 45
 
1.7%

Most occurring characters

ValueCountFrequency (%)
s 3673
21.0%
o 1674
9.6%
1300
 
7.4%
n 1255
 
7.2%
a 1187
 
6.8%
C 1187
 
6.8%
l 1187
 
6.8%
m 1063
 
6.1%
c 837
 
4.8%
E 837
 
4.8%
Other values (9) 3254
18.6%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 13554
77.7%
Uppercase Letter 2600
 
14.9%
Space Separator 1300
 
7.4%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
s 3673
27.1%
o 1674
12.4%
n 1255
 
9.3%
a 1187
 
8.8%
l 1187
 
8.8%
m 1063
 
7.8%
c 837
 
6.2%
y 837
 
6.2%
i 576
 
4.2%
u 531
 
3.9%
Other values (3) 734
 
5.4%
Uppercase Letter
ValueCountFrequency (%)
C 1187
45.7%
E 837
32.2%
B 418
 
16.1%
P 113
 
4.3%
F 45
 
1.7%
Space Separator
ValueCountFrequency (%)
1300
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 16154
92.6%
Common 1300
 
7.4%

Most frequent character per script

Latin
ValueCountFrequency (%)
s 3673
22.7%
o 1674
10.4%
n 1255
 
7.8%
a 1187
 
7.3%
C 1187
 
7.3%
l 1187
 
7.3%
m 1063
 
6.6%
c 837
 
5.2%
E 837
 
5.2%
y 837
 
5.2%
Other values (8) 2417
15.0%
Common
ValueCountFrequency (%)
1300
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 17454
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
s 3673
21.0%
o 1674
9.6%
1300
 
7.4%
n 1255
 
7.2%
a 1187
 
6.8%
C 1187
 
6.8%
l 1187
 
6.8%
m 1063
 
6.1%
c 837
 
4.8%
E 837
 
4.8%
Other values (9) 3254
18.6%

route
Text

Distinct824
Distinct (%)63.4%
Missing0
Missing (%)0.0%
Memory size10.3 KiB
2024-02-05T02:00:11.029652image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Length

Max length46
Median length41
Mean length22.403846
Min length3

Characters and Unicode

Total characters29125
Distinct characters60
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique614 ?
Unique (%)47.2%

Sample

1st rowBoston to Düsseldorf via London
2nd rowSao Paulo to London Heathrow
3rd rowLondon Heathrow to Lisbon
4th rowLondon to Hong Kong
5th rowDusseldorf (DUS) to Miami (MIA)
ValueCountFrequency (%)
to 1296
25.9%
london 1104
22.1%
heathrow 305
 
6.1%
via 237
 
4.7%
gatwick 121
 
2.4%
new 48
 
1.0%
york 45
 
0.9%
johannesburg 43
 
0.9%
singapore 40
 
0.8%
los 39
 
0.8%
Other values (274) 1718
34.4%
2024-02-05T02:00:11.772502image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
o 4684
16.1%
3779
13.0%
n 3192
11.0%
t 2153
 
7.4%
a 2034
 
7.0%
d 1353
 
4.6%
e 1309
 
4.5%
L 1225
 
4.2%
i 1076
 
3.7%
r 1061
 
3.6%
Other values (50) 7259
24.9%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 21824
74.9%
Space Separator 3779
 
13.0%
Uppercase Letter 3502
 
12.0%
Other Punctuation 10
 
< 0.1%
Dash Punctuation 4
 
< 0.1%
Open Punctuation 3
 
< 0.1%
Close Punctuation 3
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
o 4684
21.5%
n 3192
14.6%
t 2153
9.9%
a 2034
9.3%
d 1353
 
6.2%
e 1309
 
6.0%
i 1076
 
4.9%
r 1061
 
4.9%
s 622
 
2.9%
h 613
 
2.8%
Other values (18) 3727
17.1%
Uppercase Letter
ValueCountFrequency (%)
L 1225
35.0%
H 353
 
10.1%
M 201
 
5.7%
G 188
 
5.4%
S 175
 
5.0%
B 165
 
4.7%
A 162
 
4.6%
C 154
 
4.4%
D 130
 
3.7%
T 108
 
3.1%
Other values (16) 641
18.3%
Other Punctuation
ValueCountFrequency (%)
/ 7
70.0%
, 3
30.0%
Space Separator
ValueCountFrequency (%)
3779
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 25326
87.0%
Common 3799
 
13.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
o 4684
18.5%
n 3192
12.6%
t 2153
 
8.5%
a 2034
 
8.0%
d 1353
 
5.3%
e 1309
 
5.2%
L 1225
 
4.8%
i 1076
 
4.2%
r 1061
 
4.2%
s 622
 
2.5%
Other values (44) 6617
26.1%
Common
ValueCountFrequency (%)
3779
99.5%
/ 7
 
0.2%
- 4
 
0.1%
( 3
 
0.1%
) 3
 
0.1%
, 3
 
0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 29118
> 99.9%
None 7
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
o 4684
16.1%
3779
13.0%
n 3192
11.0%
t 2153
 
7.4%
a 2034
 
7.0%
d 1353
 
4.6%
e 1309
 
4.5%
L 1225
 
4.2%
i 1076
 
3.7%
r 1061
 
3.6%
Other values (46) 7252
24.9%
None
ValueCountFrequency (%)
ü 3
42.9%
ã 2
28.6%
İ 1
 
14.3%
é 1
 
14.3%
Distinct74
Distinct (%)5.7%
Missing0
Missing (%)0.0%
Memory size10.3 KiB
Minimum2017-08-01 00:00:00
Maximum2024-01-01 00:00:00
2024-02-05T02:00:12.080384image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
2024-02-05T02:00:12.537971image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

vader_sentiment
Real number (ℝ)

HIGH CORRELATION 

Distinct1123
Distinct (%)86.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.040309462
Minimum-0.9975
Maximum0.9992
Zeros6
Zeros (%)0.5%
Negative642
Negative (%)49.4%
Memory size10.3 KiB
2024-02-05T02:00:13.079305image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Quantile statistics

Minimum-0.9975
5-th percentile-0.956
Q1-0.78945
median0.0186
Q30.902425
95-th percentile0.988505
Maximum0.9992
Range1.9967
Interquartile range (IQR)1.691875

Descriptive statistics

Standard deviation0.78579572
Coefficient of variation (CV)19.494076
Kurtosis-1.7485178
Mean0.040309462
Median Absolute Deviation (MAD)0.8472
Skewness-0.012072807
Sum52.4023
Variance0.61747491
MonotonicityNot monotonic
2024-02-05T02:00:13.646383image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 6
 
0.5%
-0.0516 5
 
0.4%
-0.7717 5
 
0.4%
0.9953 4
 
0.3%
-0.8957 4
 
0.3%
0.4404 4
 
0.3%
-0.4215 3
 
0.2%
0.9827 3
 
0.2%
0.9628 3
 
0.2%
0.9744 3
 
0.2%
Other values (1113) 1260
96.9%
ValueCountFrequency (%)
-0.9975 1
0.1%
-0.9961 1
0.1%
-0.9944 1
0.1%
-0.9925 1
0.1%
-0.9905 1
0.1%
-0.9885 1
0.1%
-0.9883 1
0.1%
-0.988 1
0.1%
-0.9872 1
0.1%
-0.9853 1
0.1%
ValueCountFrequency (%)
0.9992 2
0.2%
0.9978 2
0.2%
0.9977 1
 
0.1%
0.9976 1
 
0.1%
0.9966 1
 
0.1%
0.9965 1
 
0.1%
0.9961 1
 
0.1%
0.9959 1
 
0.1%
0.9958 1
 
0.1%
0.9953 4
0.3%

vader_nnp
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size10.3 KiB

vader_upper_binned
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.8 KiB
0.75
449 
-1.0
373 
-0.75
130 
0.5
93 
-0.5
87 
Other values (3)
168 

Length

Max length5
Median length4
Mean length4.04
Min length3

Characters and Unicode

Total characters5252
Distinct characters7
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row-1.0
2nd row0.5
3rd row0.75
4th row0.25
5th row-1.0

Common Values

ValueCountFrequency (%)
0.75 449
34.5%
-1.0 373
28.7%
-0.75 130
 
10.0%
0.5 93
 
7.2%
-0.5 87
 
6.7%
0.25 67
 
5.2%
-0.25 58
 
4.5%
0.0 43
 
3.3%

Length

2024-02-05T02:00:14.204809image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-02-05T02:00:14.646702image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
ValueCountFrequency (%)
0.75 579
44.5%
1.0 373
28.7%
0.5 180
 
13.8%
0.25 125
 
9.6%
0.0 43
 
3.3%

Most occurring characters

ValueCountFrequency (%)
0 1343
25.6%
. 1300
24.8%
5 884
16.8%
- 648
12.3%
7 579
11.0%
1 373
 
7.1%
2 125
 
2.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 3304
62.9%
Other Punctuation 1300
 
24.8%
Dash Punctuation 648
 
12.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 1343
40.6%
5 884
26.8%
7 579
17.5%
1 373
 
11.3%
2 125
 
3.8%
Other Punctuation
ValueCountFrequency (%)
. 1300
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 648
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 5252
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 1343
25.6%
. 1300
24.8%
5 884
16.8%
- 648
12.3%
7 579
11.0%
1 373
 
7.1%
2 125
 
2.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 5252
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 1343
25.6%
. 1300
24.8%
5 884
16.8%
- 648
12.3%
7 579
11.0%
1 373
 
7.1%
2 125
 
2.4%

Interactions

2024-02-05T01:59:50.720758image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
2024-02-05T01:59:50.074724image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
2024-02-05T01:59:51.043750image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
2024-02-05T01:59:50.380752image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/

Correlations

2024-02-05T02:00:14.957997image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
user_ratingsvader_sentimentwould_recommed_to_otherstravel_typeseatvader_upper_binned
user_ratings1.0000.6950.9200.0800.1370.283
vader_sentiment0.6951.0000.6960.0670.0800.845
would_recommed_to_others0.9200.6961.0000.1430.1320.695
travel_type0.0800.0670.1431.0000.1280.050
seat0.1370.0800.1320.1281.0000.078
vader_upper_binned0.2830.8450.6950.0500.0781.000

Missing values

2024-02-05T01:59:51.578558image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
A simple visualization of nullity by column.
2024-02-05T01:59:52.439580image/svg+xmlMatplotlib v3.7.4, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

titlereviewspublished_datesuser_nameuser_locationuser_ratingstrip_detailswould_recommed_to_othersreviews_lemm_spacytitle_lemm_spacyaircrafttravel_typeseatroutedate_flownvader_sentimentvader_nnpvader_upper_binned
0“Worst service ever”Worst service ever. Lost baggage because of delayed flight and missed connection and no one is helping to get it back. British Airways website is broken so it doesn’t let me fill missing report and doesn’t give me missing file report number and so no way to contact British Airways because they have dumbest ever AI chatbot.2024-01-23Chirag ThummarGermany1Type Of TravellerSolo Leisure\nSeat TypeEconomy Class\nRouteBoston to Düsseldorf via London\nDate FlownJanuary 2024nbad service lose baggage delay flight miss connection help british airways website break let fill missing report missing file report number way contact british airway dumb ai chatbotbad serviceunkSolo LeisureEconomy ClassBoston to Düsseldorf via LondonJanuary 2024-0.966(0.349, 0.604, 0.047)-1.000
1"unprofessional attitude of the pilots"BA 246 21JAN 2023 Did not appreciate the unprofessional attitude of the pilots. Flight scheduled departure 16:20. Advised boarding time 15:20. Whole flight full of passengers waiting at the gate to board at 15:20. 15:40 the cabin crew board. 15:55 the pilots board - each with a Sao Paulo Airport Duty Free branded shopping bag. 16:20 the flight is still boarding. Finally pushes back just before 17:00, 40 minutes late. Captain came on the intercom to announce the delay was due to 'traffic between the crew hotel and the airport'. Sorry Captain the whole plane saw you and your pilot colleagues board fifteen minutes after the cabin crew clutching your duty free that you and your pilot colleagues still made time to stop for.2024-01-21D CarrenoUnited Kingdom6AircraftA350\nType Of TravellerBusiness\nSeat TypeEconomy Class\nRouteSao Paulo to London Heathrow\nDate FlownJanuary 2024nba 246 21jan 2023 appreciate unprofessional attitude pilot flight schedule departure 1620 advise boarding time 1520 flight passenger wait gate board 1520 1540 cabin crew board 1555 pilot board sao paulo airport duty free brand shopping bag 1620 flight boarding finally push 1700 40 minute late captain come intercom announce delay traffic crew hotel airport sorry captain plane pilot colleague board minute cabin crew clutch duty free pilot colleague time stopunprofessional attitude pilotA350BusinessEconomy ClassSao Paulo to London HeathrowJanuary 20240.501(0.06, 0.871, 0.069)0.500
2“Next time it will be Jet2”Not a great experience. I could not check in online as two separate parts of the BA computer system do not talk to each other. At LHR a delightful check in clerk sorted it quickly, manually! We boarded on time, but luggage loading had to be halted as the Captain spotted a technical issue and an engineer was called. By the time it was sorted we had missed our slot so took off an hour behind schedule. The flight was uneventful, but the plane had clearly seen better days, legroom was appalling and the handout of a small bottle of water and a soggy cookie made one wish for the days when flying BA meant something special. Next time it will be Jet2.2024-01-18Simon ChannonUnited Kingdom3AircraftA320\nType Of TravellerCouple Leisure\nSeat TypeEconomy Class\nRouteLondon Heathrow to Lisbon\nDate FlownJanuary 2024ngreat experience check online separate ba computer system talk lhr delightful check clerk sort quickly manually board time luggage loading halt captain spot technical issue engineer time sort miss slot hour schedule flight uneventful plane clearly day legroom appalling handout small bottle water soggy cookie wish day fly ba mean special time jet2time jet2A320Couple LeisureEconomy ClassLondon Heathrow to LisbonJanuary 20240.875(0.058, 0.819, 0.122)0.750
3“become the Ryanair of long-haul travel”I was excited to fly BA as I'd not travelled with them long haul for over 25yrs. I've travelled to Australia on many occasions, so I've pretty much travelled with them all. Terrible was my experience. BA have become the Ryanair of long-haul travel, riding on their previous good name and reputation. We were delayed for 5hrs at the terminal, where we were offered one glass of water and then at the last minute our meal - with no additional drinks offered. The charging points were outdated and 3 out of 5 didn't work (family of five travelling). The in flight entertainment was also outdated and the movies available were poor compared to other airlines. The food was atrocious - we flew BA LHR-HongKong and return and Cathay HK-Australia return and the comparison was vast. We were offered pre meal drinks and snacks, drinks with our meal, a menu for our flights so we knew our choices, the quality of the food was vastly better with Cathay. Our luggage was lost for nearly two hours in Hong Kong and when we arrived into London, one of our bags was so badly damaged it was unusable. The only redeeming part was the crew on our return flight were amazing. Severine was an angel and helped make the journey more pleasant for my kids.2024-01-18Melissa HarrisUnited Kingdom2Type Of TravellerFamily Leisure\nSeat TypeEconomy Class\nRouteLondon to Hong Kong \nDate FlownJanuary 2024nexcited fly ba d travel long haul 25yr ve travel australia occasion ve pretty travel terrible experience ba ryanair longhaul travel riding previous good reputation delay 5hrs terminal offer glass water minute meal additional drink offer charge point outdate 3 5 work family travel flight entertainment outdate movie available poor compare airline food atrocious fly ba lhrhongkong return cathay hkaustralia return comparison vast offer pre meal drink snack drink meal menu flight know choice quality food vastly cathay luggage lose nearly hour hong kong arrive london bag badly damage unusable redeem crew return flight amazing severine angel help journey pleasant kidryanair longhaul travelunkFamily LeisureEconomy ClassLondon to Hong KongJanuary 20240.477(0.079, 0.833, 0.088)0.250
4“They never help us”I just want to warn everyone of the worst customer service experience ever! It really looks like British Airways customer service over the phone are trained to not help you in anyway and to create more problems rather than solving them. Last week we called British Airways to make a reservation for the family. At the time we explained to the customer service representative that we wanted to make a booking and then pay with a transfer of miles from American Express. The representative told us that he could not make the reservation until the miles were in the account, and asked us to contact American Express and make the transfer so that the booking could be made. The conversation was recorded by British Airways and could be checked. We immediately called AMEX (within 30 minutes) and solicited the transfer of 500K miles. AMEX clearly stated to us whether we were sure as the transfer was not reversible. We said that it was fine since we had checked previously with British Airways. We then called British Airways immediately to make our reservation to Miami. They confirmed that the miles arrived to our account, but to our surprise they told us that there was no space (not even one seat to Miami) and that we could not use the miles. We explained the situation and how we were led to believe that we could have a flight with miles if we transferred the miles, but all this went on deaf ears. We called the German office, which was absolutely unhelpful, so we also called UK customer service which was just as unhelpful. No manager was able to open a flight for us with miles and they just kept repeating that this was not possible (even though we if we paid for the flight and got the seats and also seats were available if we would have had gold status). In the end British Airways took absolutely no responsibility for causing the problem, did not give us a solution, kept our miles and we have to pay for a trip to Miami. With this service to their customers this is a company that should not be in business. Every time we call they made us wait for over 45 minutes then they answer and put us on hold, I have 2 days of waiting and talking with British Airways for over 2 hours each day, we were on the line for over 45 minutes each time. We were told by the lady agent to hang up the phone as I was too long on the phone and she had other customers? And we are not customers? They never help us.2024-01-17Ivana SquassabiaGermany1Type Of TravellerFamily Leisure\nSeat TypeBusiness Class\nRouteDusseldorf (DUS) to Miami (MIA) \nDate FlownJanuary 2024nwant warn bad customer service experience look like british airways customer service phone train help create problem solve week british airway reservation family time explain customer service representative want booking pay transfer mile american express representative tell reservation mile account ask contact american express transfer booking conversation record british airways check immediately amex 30 minute solicit transfer 500k mile amex clearly state sure transfer reversible fine check previously british airways british airway immediately reservation miami confirm mile arrive account surprise tell space seat miami use mile explain situation lead believe flight mile transfer mile deaf ear german office absolutely unhelpful uk customer service unhelpful manager able open flight mile repeat possible pay flight seat seat available gold status end british airways absolutely responsibility cause problem solution mile pay trip miami service customer company business time wait 45 minute answer hold 2 day wait talk british airway 2 hour day line 45 minute time tell lady agent hang phone long phone customer customer helphelpunkFamily LeisureBusiness ClassDusseldorf (DUS) to Miami (MIA)January 2024-0.884(0.055, 0.909, 0.036)-1.000
5“uncomfortable seat and disgusting food”Paid for business class travelling Cairo to London Heathrow but all I got was an economy seat. Only difference from economy is middle seat was vacant. Couldn't recline, no entertainment for the 5hr+ flight, uncomfortable seat and disgusting food. Put in a formal complaint 3 days ago and had no reply. BA's account on X is hacked. Got approached by scammers after posting there and even after flagging this to BA nothing done about it. Just disgusting. Avoid.2024-01-16Fady MagdyUnited Kingdom1Type Of TravellerFamily Leisure\nSeat TypeBusiness Class\nRouteCairo to London Heathrow\nDate FlownJanuary 2024npay business class travel cairo london heathrow economy seat difference economy middle seat vacant recline entertainment 5hr flight uncomfortable seat disgusting food formal complaint 3 day ago reply bas account x hack approach scammer post flag ba disgusting avoiduncomfortable seat disgusting foodunkFamily LeisureBusiness ClassCairo to London HeathrowJanuary 2024-0.972(0.253, 0.721, 0.026)-1.000
6"Zero customer service"The plane was extremely dirty with chocolate smudged all over mine and my children's seats. I had to wipe down all the seats. After we landed I immediately realized I left my camera with it's bag in the airplane overhead cabin. They would not let me back on the plane for security reasons so I went to The British Airways team on ground & they refused to contact cabin crew only until we threw up a massive fuss then the manager reluctantly agreed which by that point cabin crew had disembarked. Now it's been over 3 weeks with no sign of my camera so it is assumed stolen. I have complained to British Airways and all I get is an automated/generic response to keep checking with Lost Property. Zero customer service for their regular customers and this all could have been mitigated if they had been willing to help at the very beginning - very disappointed.2024-01-15A KarsinIreland1Type Of TravellerFamily Leisure\nSeat TypeEconomy Class\nRouteDublin to London Heathrow\nDate FlownJanuary 2024nplane extremely dirty chocolate smudge children seat wipe seat land immediately realize leave camera bag airplane overhead cabin let plane security reason british airways team ground refuse contact cabin crew throw massive fuss manager reluctantly agree point cabin crew disembark 3 week sign camera assume steal complain british airways automatedgeneric response check lose property zero customer service regular customer mitigate willing help beginning disappointedzero customer serviceunkFamily LeisureEconomy ClassDublin to London HeathrowJanuary 2024-0.908(0.119, 0.839, 0.042)-1.000
7"baggage arrival nearly took 1.5 hours"Overall journey wasn’t bad however at the end, the baggage arrival nearly took 1.5 hours (more than actual flight time). Baggage of other flights arriving after had been delivered whereas the baggage staff on airport had no clue and information as to why baggage of this flight hasn’t arrived. They raised their hands saying they can’t do anything further. Poor communication and no customer facing skills.2024-01-12Muhammad YasinUnited Kingdom4Type Of TravellerBusiness\nSeat TypeEconomy Class\nRouteGlasgow to London\nDate FlownJanuary 2024noverall journey bad end baggage arrival nearly 15 hour actual flight time baggage flight arrive deliver baggage staff airport clue information baggage flight arrive raise hand poor communication customer face skillbaggage arrival nearly 15 hourunkBusinessEconomy ClassGlasgow to LondonJanuary 2024-0.875(0.151, 0.849, 0.0)-1.000
8"Overall very satisfied"Overall very satisfied. Ground staff member at YVR was extremely helpful & courteous. A350 was only a few months old, so seats were in good order & comfortable by the standards of a modern day Y class seat, although the very small washroom was already starting to look a bit shabby. Cabin crew very friendly & professional, & meal service carried out at reasonable time in the flight. Choice of 2 options for the main meal which was the same for both legs of my journey 1 month apart. Flight departed on time but unfortunately upon landing at LHR we were unable to deplane for quite some time due to a staffing issue at LHR which so not the fault of the airline, and we were given frequent updates on the situation from the flight manager & the flight deck.2024-01-12S KeaneUnited Kingdom9AircraftA350-1000\nType Of TravellerSolo Leisure\nSeat TypeEconomy Class\nRouteVancouver to London\nDate FlownJanuary 2024yoverall satisfied ground staff member yvr extremely helpful courteous a350 month old seat good order comfortable standard modern day y class seat small washroom start look bit shabby cabin crew friendly professional meal service carry reasonable time flight choice 2 option main meal leg journey 1 month apart flight depart time unfortunately land lhr unable deplane time staffing issue lhr fault airline frequent update situation flight manager flight deckoverall satisfiedA350-1000Solo LeisureEconomy ClassVancouver to LondonJanuary 20240.872(0.021, 0.874, 0.106)0.750
9"airline is a total disgrace"As always when I fly BA it was a total shambles. I was booked Manchester - London - Madrid , BA first leg and Iberia 2nd, I try wherever possible to avoid BA, however the Manchester - London was late, however I ran for my IB flight and got to B gates just as boarding started, being Group 1 I went to board and the gate sounded an alarm, BA had removed me from the IB flight to a BA flight 3 hours later! As BA had reissued the ticket IB could not put me back on the flight, so 3 hours wasted because of BA’s total incompetence. This airline is a total disgrace, the crew were not nice, typical BA crew oh im so fabulous I don't need to be nice to paying passengers, club europe cramped and terrible food!2024-01-09Neil JonesSpain1AircraftA320\nType Of TravellerBusiness\nSeat TypeBusiness Class\nRouteHeathrow to Madrid\nDate FlownOctober 2023nfly ba total shamble book manchester london madrid ba leg iberia 2nd try possible avoid ba manchester london late run ib flight b gate boarding start group 1 board gate sound alarm ba remove ib flight ba flight 3 hour later ba reissue ticket ib flight 3 hour waste bas total incompetence airline total disgrace crew nice typical ba crew oh m fabulous need nice pay passenger club europe cramp terrible foodairline total disgraceA320BusinessBusiness ClassHeathrow to MadridOctober 2023-0.918(0.132, 0.823, 0.045)-1.000
titlereviewspublished_datesuser_nameuser_locationuser_ratingstrip_detailswould_recommed_to_othersreviews_lemm_spacytitle_lemm_spacyaircrafttravel_typeseatroutedate_flownvader_sentimentvader_nnpvader_upper_binned
1290"additional payment to select seats"Dubai to London Heathrow. It's bad that BA requests additional payment to select seats before the check-in. If flying solo it's not a big issue, but with any companion (in this case I was with my son of 10) it would have been an issue to be separate. This also means that if there are 3 or 4 flights, and a group of two (as in my case) the difference would be substantial, up to approx 1000$. Lucky enough at least on the return flight we were able to select the middle seats because the flight wasn't full. On board service was decent. Professional, courteous and friendly attendants. Toilets in the second half of the flight weren't too clean. Flat seats in business class are outdated but comfortable for a nice sleep. The aircraft did not have WiFi.2018-04-0314 reviewsN SalitoUnited Arab Emirates7AircraftBoeing 747\nType Of TravellerFamily Leisure\nSeat TypeBusiness Class\nRouteDubai to London Heathrow\nDate FlownMarch 2018ydubai london heathrow bad ba request additional payment select seat checkin fly solo big issue companion case son 10 issue separate mean 3 4 flight group case difference substantial approx 1000 lucky return flight able select middle seat flight board service decent professional courteous friendly attendant toilet second half flight clean flat seat business class outdated comfortable nice sleep aircraft wifiadditional payment select seatBoeing 747Family LeisureBusiness ClassDubai to London HeathrowMarch 20180.962(0.033, 0.823, 0.144)0.750
1291"outdated, unclean and uncomfortable"London to Las Vegas. Disappointed at BA - flights were delayed (my partner took the same outbound flight on a different day and was delayed as well by 2-3hrs). Aircraft interior was outdated, unclean and uncomfortable seats with very small legroom space. No safety video which was surprising as most long haul flights include this. Food was tasteless and I did skip a meal in the end - during one of the snack times we weren't given the options by our FA but the guy sat next to us who was served by another FA was given different options. Inflight entertainment poor with very limited choices and monitors were very old. To ensure that I sit with my partner on the return flight, we paid to reserve our seats - not impressed by this especially when we realised that the legroom space for my partner was obstructed by a broke IFE box which was loosely fitted so the door kept opening taking his legroom space as well as exposing the cables in the box which if you knocked it down would affect his monitor. Learnt our lessons, next time we will not fly BA!2018-04-03T LeaneUnited Kingdom2Type Of TravellerCouple Leisure\nSeat TypeEconomy Class\nRouteLondon to Las Vegas \nDate FlownMarch 2018nlondon las vegas disappoint ba flight delay partner outbound flight different day delay 23hrs aircraft interior outdate unclean uncomfortable seat small legroom space safety video surprising long haul flight include food tasteless skip meal end snack time option fa guy sit serve fa different option inflight entertainment poor limited choice monitor old ensure sit partner return flight pay reserve seat impress especially realise legroom space partner obstruct broke ife box loosely fit door open legroom space expose cable box knock affect monitor learn lesson time fly baoutdate unclean uncomfortableunkCouple LeisureEconomy ClassLondon to Las VegasMarch 2018-0.877(0.116, 0.823, 0.061)-1.000
1292"the utmost courtesy and assistance"Tampa to Gatwick. I am a disabled traveller with considerable mobility issues. As I usually travel alone I can find it extremely difficult. However, from the moment I arrived at the check in desk in Tampa I was met with the utmost courtesy and assistance. From the check in clerk at business class waving me forward to use his terminal things just went from excellent to exceptional. I was helped to put my suitcase onto the conveyor scale and assisted with every step of the way until the aircraft door. Every person was polite, helpful and went out of their way to make my journey as pleasant as possible. I witnessed such kindness and this is what I have come to expect and value from British Airways. Having used other airlines in the past - I am converted - I will not use any other airline in future.2018-04-03E PentonUnited Kingdom10Type Of TravellerSolo Leisure\nSeat TypeEconomy Class\nRouteTampa to Gatwick\nDate FlownMarch 2018ytampa gatwick disabled traveller considerable mobility issue usually travel find extremely difficult moment arrive check desk tampa meet utmost courtesy assistance check clerk business class wave forward use terminal thing excellent exceptional help suitcase conveyor scale assist step way aircraft door person polite helpful way journey pleasant possible witness kindness come expect value british airway having airline past convert use airline futureutmost courtesy assistanceunkSolo LeisureEconomy ClassTampa to GatwickMarch 20180.917(0.029, 0.862, 0.109)0.750
1293"pleasantly surprised to be upgraded"Heathrow to Keflavik. I had booked economy, was pleasantly surprised to be upgraded when I checked in online. Priority boarding worked well and even though the flight was full there was no overhead locker range. The inflight meal was prawns was generous along with a good selection of wine. Off loading was straightforward. The return flight was on time, the pre booked emergency seat had more leg room the premium seat. M&S food service was OK. The cabin crews were slow at taking payment. Overall similar experience to an easyjet flight.2018-04-023 reviewsAlly WhartonUnited Kingdom7AircraftA320\nType Of TravellerBusiness\nSeat TypeEconomy Class\nRouteHeathrow to Keflavik\nDate FlownMarch 2018yheathrow keflavik book economy pleasantly surprised upgrade check online priority boarding work flight overhead locker range inflight meal prawn generous good selection wine loading straightforward return flight time pre book emergency seat leg room premium seat ms food service ok cabin crew slow payment overall similar experience easyjet flightpleasantly surprise upgradeA320BusinessEconomy ClassHeathrow to KeflavikMarch 20180.818(0.047, 0.823, 0.13)0.750
1294"crew very friendly and professional"London to Muscat first class. First time trying out first class on BA. Check-in was fairly quick and efficient, didn't have much luggage, but the first wing did not feel very exclusive. I had selected window seat in advance and this was confirmed and still intact as I got printed boarding pass. Concorde room was nice, well designed but quite crowded in some places. Had to ask for a champagne two times out in the terrace, before it got served a good 20 minutes later. Checkout out the cabana for an hour, which was not very appealing at all, and managed to miss the first 5 min of the 15min treatment I booked for the Spa. Onboard was informed there was a problem with the Seat I had selected, and was issued a new aisle seat, which was disappointing. Upon entering the first class cabin, I had a quick look at the seat, and it was not immediately apparent, there was something wrong. I asked a crew to check and they came back to confirm that I will indeed not be able to sit there, but there was no explanation of what was wrong given. I did not want to waste any time to settle in, the crew looking after me introduced himself and served me champagne and warm nuts as well as offering some magazines to read. Seat was comfortable and spacious enough and seemed fairly private, with a small wardrobe to hang jacket. The TV screen seemed quite large and high quality. Unfortunately the seat controls were not super responsive, and neither was the remote for the TV. Soon after take off, I was informed I could eat when I like. Arabic starter was great. Had pre-selected main meal online. Meal was of good quality and cooked well. Had a dessert and the mixed cheese plate (not as good as other cheese I've had in some Business class). Surprisingly the entertainment system had a rather limited selection, I imagine on two ultra-long flights in the same month, one might run out of anything of interest to watch. After finishing the one film I decided to watch, I decided to try get some sleep. Crew made the bedding while I tried to put on the pyjamas in the tiny first class bathroom. Bedding was of good quality and comfortable enough. I missed breakfast, as I was still rather full from the dinner and pre-dinner at the lounge. Overall, I was reasonably happy with the flight and the product. The crew were very friendly and professional. Given this was first class, have to admit there was no wow factor, either with the soft product or ground experience. I managed to book flights for a good price during a promo, otherwise it would personally not be worth the price tag for a fairly short flight.2018-04-01F HamzilUnited Kingdom7AircraftBoeing 787-9\nType Of TravellerSolo Leisure\nSeat TypeFirst Class\nRouteLondon to Muscat\nDate FlownMarch 2018ylondon muscat class time try class ba checkin fairly quick efficient luggage wing feel exclusive select window seat advance confirm intact print boarding pass concorde room nice design crowded place ask champagne time terrace serve good 20 minute later checkout cabana hour appealing manage miss 5 min 15min treatment book spa onboard inform problem seat select issue new aisle seat disappointing enter class cabin quick look seat immediately apparent wrong ask crew check come confirm able sit explanation wrong want waste time settle crew look introduce serve champagne warm nut offer magazine read seat comfortable spacious fairly private small wardrobe hang jacket tv screen large high quality unfortunately seat control super responsive remote tv soon inform eat like arabic starter great preselecte main meal online meal good quality cook dessert mixed cheese plate good cheese ve business class surprisingly entertainment system limited selection imagine ultralong flight month run interest watch finish film decide watch decide try sleep crew bedding try pyjama tiny class bathroom bedding good quality comfortable miss breakfast dinner predinner lounge overall reasonably happy flight product crew friendly professional class admit wow factor soft product ground experience manage book flight good price promo personally worth price tag fairly short flightcrew friendly professionalBoeing 787-9Solo LeisureFirst ClassLondon to MuscatMarch 20180.986(0.091, 0.765, 0.144)0.750
1295"entertainment was not working"My family and I travelled from Cape Town to London on the 10th March 2018. We have a 1 year old and a 4 year old. Once seated, we realised that our entertainment system was not working. The cabin light for all seats that we had booked were not working either. There was minimal effort from the cabin team to try and resolve this. As it was a night flight, my wife and I had to see to our 1 year old in the dark. Any help we needed required us to walk to the galley to receive any assistance. As BAs safety demonstration prior to take off is on video, we didn't receive this. The flight was the worst airline experience we've had. I doubt I'll ever fly with BA again.2018-04-01Muhammad KajeeUnited Kingdom1Type Of TravellerFamily Leisure\nSeat TypeEconomy Class\nRouteCape Town to London\nDate FlownMarch 2018nfamily travel cape town london 10th march 2018 1 year old 4 year old seat realise entertainment system work cabin light seat book work minimal effort cabin team try resolve night flight wife 1 year old dark help need require walk galley receive assistance bas safety demonstration prior video receive flight bad airline experience ve doubt ill fly baentertainment workunkFamily LeisureEconomy ClassCape Town to LondonMarch 20180.572(0.046, 0.869, 0.085)0.500
1296"staff try so very hard to please"Gatwick to Madeira. The flight left on time and arrived early, slept as early morning flight. The plane was not very clean, grubby tray between seats and ingrained dirt in the spokes of the seats. The staff were pleasant. Breakfast was offered and my children felt it was adequate. The return was poorly organised, no use of fast track security for business class passengers. Long queue for boarding and a grubby plane. Really no point in paying for business class. The staff try so very hard to please the passengers but nearly 4 hours and no entertainment, dog-eared magazines. Quickly disembarked and swiftly through immigration.2018-03-30P DeanUnited Kingdom4AircraftA320\nType Of TravellerFamily Leisure\nSeat TypeBusiness Class\nRouteGatwick to Madeira\nDate FlownMarch 2018ngatwick madeira flight leave time arrive early sleep early morning flight plane clean grubby tray seat ingrain dirt spoke seat staff pleasant breakfast offer child feel adequate return poorly organise use fast track security business class passenger long queue boarding grubby plane point pay business class staff try hard passenger nearly 4 hour entertainment dogeare magazine quickly disembark swiftly immigrationstaff try hardA320Family LeisureBusiness ClassGatwick to MadeiraMarch 2018-0.099(0.098, 0.816, 0.086)-0.250
1297"extremely unprofessional"London to Casablanca. Their customer service quality in Heathrow Terminal 3 is very patchy. For background, my initial flight was with TAP Portugal which got cancelled, then rebooked to BA. My second flight had further issue, and instead of requesting TAP to rebook me, BA took the liberty of rebooking a 3rd flight for me - which turned out to be overbooked. This then caused me having to liaise with both TAP and BA to rebook my 4th flight - I was tossed around by both customer care telling me it's not their problem. TAP can no longer rebook me on another flight as they have lost the right to alter the ticket as soon as BA rebooked me on the 3rd flight. I was initially served by a very helpful staff who attends to my rebooking issue - the last flight I was rebooked was overbooked. However, later on I was passed on to a couple of rude staff that were reluctant to serve me as it was 15 minutes past their end of shift. They were also talking about me in front of me and accused me of taking advantage of BA. This is very rude and extremely unprofessional. I've never had this treatment during my 10+ years of flying with various airlines, both top rated and low cost carrier.2018-03-30E ChristieUnited Kingdom2Type Of TravellerSolo Leisure\nSeat TypeEconomy Class\nRouteLondon to Casablanca\nDate FlownMarch 2018nlondon casablanca customer service quality heathrow terminal 3 patchy background initial flight tap portugal cancel rebooke ba second flight issue instead request tap rebook ba liberty rebooke 3rd flight turn overbooke cause liaise tap ba rebook 4th flight toss customer care tell problem tap long rebook flight lose right alter ticket soon ba rebooke 3rd flight initially serve helpful staff attend rebooking issue flight rebooke overbooke later pass couple rude staff reluctant serve 15 minute past end shift talk accuse advantage ba rude extremely unprofessional ve treatment 10 year fly airline rate low cost carrierextremely unprofessionalunkSolo LeisureEconomy ClassLondon to CasablancaMarch 2018-0.713(0.092, 0.843, 0.064)-0.750
1298"manager is very professional"British Airways flight manager is very professional. I travelled on BA985 from Berlin to Hong Kong via London on 19 Feb. Due to the snowy weather, my flight leaving Berlin to London was delayed, in which I was worried about missing my connecting flight from London to Hong Kong. During the flight, the manager came to me several times, explained to me the reason of flight delay, informed me about the connecting flight arrangements. Her information was very clear, trusted she has been working closely with airport ground on this. Very much appreciated for their service.2018-03-28N WangHong Kong8Type Of TravellerSolo Leisure\nSeat TypeEconomy Class\nRouteBerlin to Hong Kong via London\nDate FlownFebruary 2018ybritish airways flight manager professional travel ba985 berlin hong kong london 19 feb snowy weather flight leave berlin london delay worried miss connect flight london hong kong flight manager come time explain reason flight delay inform connect flight arrangement information clear trust work closely airport ground appreciate servicemanager professionalunkSolo LeisureEconomy ClassBerlin to Hong Kong via LondonFebruary 20180.502(0.08, 0.828, 0.092)0.500
1299"regret choosing BA"Hyderabad to Brussels via London. Didn't expect this from British Airways. For me quality hit the rock bottom. Especially the unclean flight. I would have preferred the aircraft from Brussels to London and vice versa for the long haul travel. Maybe my expectations was too high but considering the price I paid for ticket I think it's not worth it. Other airline which I used to travel had the same price and if I compare the services of that ariline I regret choosing British Airways.2018-03-28Aditya NagaramBelgium2Type Of TravellerSolo Leisure\nSeat TypeEconomy Class\nRouteHyderabad to Brussels via London\nDate FlownMarch 2018nhyderabad brussels london expect british airways quality hit rock especially unclean flight prefer aircraft brussels london vice versa long haul travel maybe expectation high consider price pay ticket think worth airline travel price compare service ariline regret choose british airwaysregret choose baunkSolo LeisureEconomy ClassHyderabad to Brussels via LondonMarch 2018-0.691(0.064, 0.936, 0.0)-0.750